create  table jms_dm.dm_transfer_mistake_send_sum_dt 
(
date_time timestamp COMMENT '' ,
center_code varchar(100) COMMENT '' ,
center_name varchar(100) COMMENT '' ,
agent_code varchar(100) COMMENT '' ,
agent_name varchar(100) COMMENT '' ,
ordersource_name varchar(100) COMMENT '' ,
mistake_cnt varchar(100) COMMENT '' ,
operate_cnt varchar(100) COMMENT '' ,
nofst_code_cnt varchar(100) COMMENT '' ,
fst_code_no_destination_cnt varchar(100) COMMENT '' ,
no_route_cnt varchar(100) COMMENT '' ,
dispatch_cnt varchar(100) COMMENT '' ,
temp_tran_cnt varchar(100) COMMENT '' ,
fstcode_err_cnt varchar(100) COMMENT '' ,
up_bagging_err_cnt varchar(100) COMMENT '' ,
equipment_factor_cnt varchar(100) COMMENT '' ,
return_cnt_cnt varchar(100) COMMENT '' ,
send_on_cnt varchar(100) COMMENT '' ,
delete_scan_cnt varchar(100) COMMENT '' ,
human_factor_cnt varchar(100) COMMENT '' ,
err_load_cnt varchar(100) COMMENT '' ,
virt_code varchar(100) COMMENT '' ,
virt_name varchar(100) COMMENT '' ,
provider_id varchar(100) COMMENT '' ,
provider_desc varchar(100) COMMENT '' ,
 varchar(100) COMMENT '' )
ENGINE=OLAP
DUPLICATE KEY(填写key)
comment 'insert overwrite table jms_dm.dm_transfer_mistake_send_sum_dt  partition (dt)'
PARTITION BY RANGE (date_time) ( 
   START ("2023-07-31") END ("2023-09-29") EVERY (INTERVAL 1 day))
DISTRIBUTED BY HASH(site_code) BUCKETS 4
PROPERTIES (
"replication_num" = "3",
"dynamic_partition.enable" = "true",
"dynamic_partition.time_unit" = "DAY",
"dynamic_partition.time_zone" = "Asia/Shanghai",
"dynamic_partition.start" = "-365",
"dynamic_partition.end" = "3",
"dynamic_partition.prefix" = "p",
"dynamic_partition.buckets" = "4",
"in_memory" = "false",
"storage_format" = "V2"
);